CREATE TABLE [dbo].[DnnProduct_TabSettings]
(
[TabID] [int] NOT NULL,
[SettingName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SettingValue] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedByUserID] [int] NULL,
[CreatedOnDate] [datetime] NULL,
[LastModifiedByUserID] [int] NULL,
[LastModifiedOnDate] [datetime] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_DnnProduct_TabSettings_TabID_SettingName] ON [dbo].[DnnProduct_TabSettings] ([TabID], [SettingName]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_TabSettings] ADD CONSTRAINT [FK_DnnProduct_TabSettings_DnnProduct_Tabs] FOREIGN KEY ([TabID]) REFERENCES [dbo].[DnnProduct_Tabs] ([TabID]) ON DELETE CASCADE
GO
